import pandas as pd
df=pd.read_excel('旅游网站精华游记数据.xlsx')
def dealPlace(place):
    s=''
    if type(place)==str:
        for c in place:
            if not(((c>='a') and (c<='z'))
                or ((c>='A') and (c<='Z'))):
                s=s+c
    else:
        s=place
    return s
def dealView(view):
    num=view
    if type(num)==str:
        if '' in num:
            if '.' in num:
                num=num.replace('.','').replace('万','000')
            else:
                num = num.replace('万', '000')
    return num
df['出发日期']=df['出发日期'].str.split(expand=True)[0]
df['天数']=df['天数'].str.slice(1,-1).astype('int')
df['人均消费（元）']=df['人均消费（元）'].str.slice(2,-1)
df['途经地点']=df['途经地点'].apply(lambda x: dealPlace(x))
df['途经地点']=df['途经地点'].str.replace('途经:','',regex=False).str.replace('>','',regex=False)
df['阅览数']=df['阅览数'].apply(lambda x: dealView(x)).astype('int')
print(df[['出发日期','天数','人均消费（元）','阅览数','途经地点']])